query run time: 0.536367654800415
Dropping table if it exists... Table dropped! Creating table KMDB016.THS_TWS_OFT_VALIDATION_TARGET_VAR... Table KMDB016.THS_TWS_OFT_VALIDATION_TARGET_VAR created! Granting SELECT Permission... SELECT Permission Granted...
| INS_UNIQUE_ID | SCORE | Y_TRUE | MODEL | |
|---|---|---|---|---|
| 0 | P000761479 | 0.000343 | 0 | AEG |
| 1 | P000832219 | 0.004995 | 0 | AEG |
| 2 | P000664806 | 0.000342 | 0 | AEG |
| 3 | P000788071 | 0.001311 | 0 | AEG |
| 4 | P000973044 | 0.000022 | 0 | AEG |
| 5 | P000849639 | 0.000118 | 0 | AEG |
| 6 | P001174102 | 0.000153 | 0 | AEG |
| 7 | P001286268 | 0.001308 | 0 | AEG |
| 8 | P001288428 | 0.000464 | 0 | AEG |
| 9 | P001396699 | 0.000218 | 0 | AEG |
| metrics | auc | cap | ks | n_obs |
|---|---|---|---|---|
| AEG | 0.83 | 0.96 | 0.54 | 2,358,191 |
| ALC | 0.83 | 0.92 | 0.51 | 2,241,189 |
| ALL | 0.84 | 0.93 | 0.51 | 2,119,109 |
| ALMR | 0.87 | 0.95 | 0.60 | 2,434,312 |
| ALS | 0.85 | 0.95 | 0.52 | 2,071,683 |
| APA | 0.89 | 0.99 | 0.60 | 2,071,683 |
| LADY | 0.85 | 0.97 | 0.56 | 658,217 |
| POST | 0.87 | 0.93 | 0.64 | 315,203 |
| TPA | 0.92 | 0.99 | 0.70 | 315,203 |
| NB | 0.79 | 0.90 | 0.42 | 2,499,904 |
| THS | 0.82 | 0.91 | 0.47 | 2,499,904 |
| TWS | 0.85 | 0.96 | 0.54 | 2,499,904 |
D:\Anaconda3\lib\site-packages\plotly\graph_objs\_deprecations.py:572: DeprecationWarning: plotly.graph_objs.YAxis is deprecated. Please replace it with one of the following more specific types - plotly.graph_objs.layout.YAxis - plotly.graph_objs.layout.scene.YAxis